Bookingpad Postgres Database Instructions ------------------------------ 1. Create the Bookingpad database (At command line: createdb bookingpad) 2. login to postgres 3. Create a bookingpad user (postgres: CREATE USER bookingpad WITH PASSWORD 'bookingpad';) 4. Grant access to the bookingpad user (postgres: GRANT ALL PRIVILEGES ON DATABASE bookingpad to bookingpad;) 5. Extract the Bookingpad_bin.zip and locate the file db/postgres/bookingpad_postgres.sql 6. Run the bookingpad_postgres.sql file into mysql (at command line: psql -h 127.0.0.1 -f bookingpad_postgres.sql -U bookingpad bookingpad) 7. Copy the file db/postgres/hibernate.cfg.xml into the ROOT/WEB-INF/classes directory 8. Edit the copied hibernate.cfg.xml file to setup the correct database, username and password.